# -*- coding: utf-8 -*-
"""
向NBA球队插入数据的SQL语句，共58个，DBMS为MySQL。
"""

# 1
insert_nba_active_team = """
INSERT INTO nba_active_team(
at_name,
at_area,
at_detailed_area
)
VALUES(%s,%s,%s);
"""

# 2
insert_nba_history_team = """
INSERT INTO nba_history_team(
ht_name
)
VALUES(%s);
"""

# 3
insert_team_brief_introduction = """
INSERT INTO team_brief_introduction(
bi_name,
bi_English_name,
bi_champion_season,
bi_retired_number
)
VALUES(%s,%s,%s,%s);
"""

# 4
insert_team_player_date_regular = """
INSERT INTO team_player_date_regular(
pdr_name,
pdr_season,
pdr_player,
pdr_appearance,
pdr_starting,
pdr_time,
pdr_shot,
pdr_shot_hit,
pdr_shot_shot,
pdr_three_points,
pdr_three_points_hit,
pdr_three_points_shot,
pdr_penalty,
pdr_penalty_hit,
pdr_penalty_shot,
pdr_backboard,
pdr_backboard_front,
pdr_backboard_back,
pdr_assist,
pdr_steal,
pdr_cap,
pdr_mistake,
pdr_foul,
pdr_score
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);
"""

# 5
insert_team_player_count_data_regular = """
INSERT INTO team_player_count_data_regular(
pcdr_name,
pcdr_season,
pcdr_total,
pcdr_session,
pcdr_win,
pcdr_negative,
pcdr_shot,
pcdr_shot_hit,
pcdr_shot_shot,
pcdr_three_points,
pcdr_three_points_hit,
pcdr_three_points_shot,
pcdr_penalty,
pcdr_penalty_hit,
pcdr_penalty_shot,
pcdr_backboard,
pcdr_backboard_front,
pcdr_backboard_back,
pcdr_assist,
pcdr_steal,
pcdr_cap,
pcdr_mistake,
pcdr_foul,
pcdr_score
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);
"""

# 6
insert_team_player_date_playoff = """
INSERT INTO team_player_date_playoff(
pdp_name,
pdp_season,
pdp_player,
pdp_appearance,
pdp_time,
pdp_shot,
pdp_shot_hit,
pdp_shot_shot,
pdp_three_points,
pdp_three_points_hit,
pdp_three_points_shot,
pdp_penalty,
pdp_penalty_hit,
pdp_penalty_shot,
pdp_backboard,
pdp_backboard_front,
pdp_backboard_back,
pdp_assist,
pdp_steal,
pdp_cap,
pdp_mistake,
pdp_foul,
pdp_score
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);
"""

# 7
insert_team_player_count_data_playoff = """
INSERT INTO team_player_count_data_playoff(
pcdp_name,
pcdp_season,
pcdp_total,
pcdp_session,
pcdp_win,
pcdp_negative,
pcdp_shot,
pcdp_shot_hit,
pcdp_shot_shot,
pcdp_three_points,
pcdp_three_points_hit,
pcdp_three_points_shot,
pcdp_penalty,
pcdp_penalty_hit,
pcdp_penalty_shot,
pcdp_backboard,
pcdp_backboard_front,
pcdp_backboard_back,
pcdp_assist,
pcdp_steal,
pcdp_cap,
pcdp_mistake,
pcdp_foul,
pcdp_score
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);
"""

# 8
insert_team_salary_situation = """
INSERT INTO team_salary_situation(
ss_name,
ss_season,
ss_player,
ss_salary
)
VALUES(%s,%s,%s,%s);
"""

# 9
insert_team_salary_count = """
INSERT INTO team_salary_count(
sc_name,
sc_season,
sc_total
)
VALUES(%s,%s,%s);
"""

# 10
insert_team_regular_star_score_total = """
INSERT INTO team_regular_star_score_total(
rsst_name,
rsst_player,
rsst_value
)
VALUES(%s,%s,%s);
"""

# 11
insert_team_regular_star_score_average = """
INSERT INTO team_regular_star_score_average(
rssa_name,
rssa_player,
rssa_value
)
VALUES(%s,%s,%s);
"""

# 12
insert_team_regular_star_backboard_total = """
INSERT INTO team_regular_star_backboard_total(
rsbt_name,
rsbt_player,
rsbt_value
)
VALUES(%s,%s,%s);
"""

# 13
insert_team_regular_star_backboard_average = """
INSERT INTO team_regular_star_backboard_average(
rsba_name,
rsba_player,
rsba_value
)
VALUES(%s,%s,%s);
"""

# 14
insert_team_regular_star_assists_total = """
INSERT INTO team_regular_star_assists_total(
rsat_name,
rsat_player,
rsat_value
)
VALUES(%s,%s,%s);
"""

# 15
insert_team_regular_star_assists_average = """
INSERT INTO team_regular_star_assists_average(
rsaa_name,
rsaa_player,
rsaa_value
)
VALUES(%s,%s,%s);
"""

# 16
insert_team_regular_star_steal_total = """
INSERT INTO team_regular_star_steal_total(
rsst_name,
rsst_player,
rsst_value
)
VALUES(%s,%s,%s);
"""

# 17
insert_team_regular_star_steal_average = """
INSERT INTO team_regular_star_steal_average(
rssa_name,
rssa_player,
rssa_value
)
VALUES(%s,%s,%s);
"""

# 18
insert_team_regular_star_cap_total = """
INSERT INTO team_regular_star_cap_total(
rsct_name,
rsct_player,
rsct_value
)
VALUES(%s,%s,%s);
"""

# 19
insert_team_regular_star_cap_average = """
INSERT INTO team_regular_star_cap_average(
rsca_name,
rsca_player,
rsca_value
)
VALUES(%s,%s,%s);
"""

# 20
insert_team_regular_star_mistake_total = """
INSERT INTO team_regular_star_mistake_total(
rsmt_name,
rsmt_player,
rsmt_value
)
VALUES(%s,%s,%s);
"""

# 21
insert_team_regular_star_mistake_average = """
INSERT INTO team_regular_star_mistake_average(
rsma_name,
rsma_player,
rsma_value
)
VALUES(%s,%s,%s);
"""

# 22
insert_team_regular_star_foul_total = """
INSERT INTO team_regular_star_foul_total(
rsft_name,
rsft_player,
rsft_value
)
VALUES(%s,%s,%s);
"""

# 23
insert_team_regular_star_foul_average = """
INSERT INTO team_regular_star_foul_average(
rsfa_name,
rsfa_player,
rsfa_value
)
VALUES(%s,%s,%s);
"""

# 24
insert_team_regular_star_hit_total = """
INSERT INTO team_regular_star_hit_total(
rsht_name,
rsht_player,
rsht_value
)
VALUES(%s,%s,%s);
"""

# 25
insert_team_regular_star_hit_rate = """
INSERT INTO team_regular_star_hit_rate(
rshr_name,
rshr_player,
rshr_value
)
VALUES(%s,%s,%s);
"""

# 26
insert_team_regular_star_ture_hit = """
INSERT INTO team_regular_star_ture_hit(
rsth_name,
rsth_player,
rsth_value
)
VALUES(%s,%s,%s);
"""

# 27
insert_team_regular_star_tp_total = """
INSERT INTO team_regular_star_tp_total(
rstt_name,
rstt_player,
rstt_value
)
VALUES(%s,%s,%s);
"""

# 28
insert_team_regular_star_tp_hit_rate = """
INSERT INTO team_regular_star_tp_hit_rate(
rsthr_name,
rsthr_player,
rsthr_value
)
VALUES(%s,%s,%s);
"""

# 29
insert_team_regular_star_penalty_total = """
INSERT INTO team_regular_star_penalty_total(
rspt_name,
rspt_player,
rspt_value
)
VALUES(%s,%s,%s);
"""

# 30
insert_team_regular_star_penalty_hit_rate = """
INSERT INTO team_regular_star_penalty_hit_rate(
rsphr_name,
rsphr_player,
rsphr_value
)
VALUES(%s,%s,%s);
"""

# 31
insert_team_regular_star_undefined_total = """
INSERT INTO team_regular_star_undefined_total(
rsut_name,
rsut_player,
rsut_value
)
VALUES(%s,%s,%s);
"""

# 32
insert_team_regular_star_undefined_average = """
INSERT INTO team_regular_star_undefined_average(
rsua_name,
rsua_player,
rsua_value
)
VALUES(%s,%s,%s);
"""

# 33
insert_team_regular_star_appearance = """
INSERT INTO team_regular_star_appearance(
rsa_name,
rsa_player,
rsa_value
)
VALUES(%s,%s,%s);
"""

# 34
insert_team_playoff_star_score_total = """
INSERT INTO team_playoff_star_score_total(
psst_name,
psst_player,
psst_value
)
VALUES(%s,%s,%s);
"""

# 35
insert_team_playoff_star_score_average = """
INSERT INTO team_playoff_star_score_average(
pssa_name,
pssa_player,
pssa_value
)
VALUES(%s,%s,%s);
"""

# 36
insert_team_playoff_star_backboard_total = """
INSERT INTO team_playoff_star_backboard_total(
psbt_name,
psbt_player,
psbt_value
)
VALUES(%s,%s,%s);
"""

# 37
insert_team_playoff_star_backboard_average = """
INSERT INTO team_playoff_star_backboard_average(
psba_name,
psba_player,
psba_value
)
VALUES(%s,%s,%s);
"""

# 38
insert_team_playoff_star_assists_total = """
INSERT INTO team_playoff_star_assists_total(
psat_name,
psat_player,
psat_value
)
VALUES(%s,%s,%s);
"""

# 39
insert_team_playoff_star_assists_average = """
INSERT INTO team_playoff_star_assists_average(
psaa_name,
psaa_player,
psaa_value
)
VALUES(%s,%s,%s);
"""

# 40
insert_team_playoff_star_steal_total = """
INSERT INTO team_playoff_star_steal_total(
psst_name,
psst_player,
psst_value
)
VALUES(%s,%s,%s);
"""

# 41
insert_team_playoff_star_steal_average = """
INSERT INTO team_playoff_star_steal_average(
pssa_name,
pssa_player,
pssa_value
)
VALUES(%s,%s,%s);
"""

# 42
insert_team_playoff_star_cap_total = """
INSERT INTO team_playoff_star_cap_total(
psct_name,
psct_player,
psct_value
)
VALUES(%s,%s,%s);
"""

# 43
insert_team_playoff_star_cap_average = """
INSERT INTO team_playoff_star_cap_average(
psca_name,
psca_player,
psca_value
)
VALUES(%s,%s,%s);
"""

# 44
insert_team_playoff_star_mistake_total = """
INSERT INTO team_playoff_star_mistake_total(
psmt_name,
psmt_player,
psmt_value
)
VALUES(%s,%s,%s);
"""

# 45
insert_team_playoff_star_mistake_average = """
INSERT INTO team_playoff_star_mistake_average(
psma_name,
psma_player,
psma_value
)
VALUES(%s,%s,%s);
"""

# 46
insert_team_playoff_star_foul_total = """
INSERT INTO team_playoff_star_foul_total(
psft_name,
psft_player,
psft_value
)
VALUES(%s,%s,%s);
"""

# 47
insert_team_playoff_star_foul_average = """
INSERT INTO team_playoff_star_foul_average(
psfa_name,
psfa_player,
psfa_value
)
VALUES(%s,%s,%s);
"""

# 48
insert_team_playoff_star_hit_total = """
INSERT INTO team_playoff_star_hit_total(
psht_name,
psht_player,
psht_value
)
VALUES(%s,%s,%s);
"""

# 49
insert_team_playoff_star_hit_rate = """
INSERT INTO team_playoff_star_hit_rate(
pshr_name,
pshr_player,
pshr_value
)
VALUES(%s,%s,%s);
"""

# 50
insert_team_playoff_star_ture_hit = """
INSERT INTO team_playoff_star_ture_hit(
psth_name,
psth_player,
psth_value
)
VALUES(%s,%s,%s);
"""

# 51
insert_team_playoff_star_tp_total = """
INSERT INTO team_playoff_star_tp_total(
pstt_name,
pstt_player,
pstt_value
)
VALUES(%s,%s,%s);
"""

# 52
insert_team_playoff_star_tp_hit_rate = """
INSERT INTO team_playoff_star_tp_hit_rate(
psthr_name,
psthr_player,
psthr_value
)
VALUES(%s,%s,%s);
"""

# 53
insert_team_playoff_star_penalty_total = """
INSERT INTO team_playoff_star_penalty_total(
pspt_name,
pspt_player,
pspt_value
)
VALUES(%s,%s,%s);
"""

# 54
insert_team_playoff_star_penalty_hit_rate = """
INSERT INTO team_playoff_star_penalty_hit_rate(
psphr_name,
psphr_player,
psphr_value
)
VALUES(%s,%s,%s);
"""

# 55
insert_team_playoff_star_undefined_total = """
INSERT INTO team_playoff_star_undefined_total(
psut_name,
psut_player,
psut_value
)
VALUES(%s,%s,%s);
"""

# 56
insert_team_playoff_star_undefined_average = """
INSERT INTO team_playoff_star_undefined_average(
psua_name,
psua_player,
psua_value
)
VALUES(%s,%s,%s);
"""

# 57
insert_team_playoff_star_appearance = """
INSERT INTO team_playoff_star_appearance(
psa_name,
psa_player,
psa_value
)
VALUES(%s,%s,%s);
"""

# 58
insert_team_superstar_peak_season_data = """
INSERT INTO team_superstar_peak_season_data(
spsd_name,
spsd_player,
spsd_season,
spsd_seasons,
spsd_average_score,
spsd_average_backboard,
spsd_average_assists,
spsd_average_cap,
spsd_average_steal
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s);
"""

